Importing products

Adding products in Afosto can be done in two ways.

• Manually adding products](/docs/afosto-cms/products/products-add/)
• Importing products via a CSV](/docs/afosto-cms/products/products-import/)

This article describes how to import products.

Please note! Import in 1 file only simple products or variable products. So if you want to add both simple and variable products create 2 files.

Here we explain how you can best build an import file for your products in order to be able to import them. In addition, it is important to correctly name the headers of your import, then they will automatically be used for importing. The import of products can be found in the gray section under products ‘Import’.

How to import

Artikelnummer (verplicht)

This can be any number, but also the article number of the supplier.

Ean

The ean, often also called barcode, ensures that products can be easily scanned at the checkout. It is also interesting information for search engines. It is advisable to use the supplier’s number for this. If the field is left blank, the system will automatically generate an EAN number.

Name (mandatory)

The name of a product is important for search engines, the url and of course customer-friendliness. It is recommended to set up the name according to a pattern, For a shoe store this could be for example:

Example:

1> {brand} {type} {category/single} {color}> Puma xjt sandal black

Short Description (required)

The short description is the subtitle of a product. This can be filled in as desired. However, it is advisable to do this according to a certain pattern.

Description

The description of the product can be entered here.

Cost

Format: 00.00 (use a dot as decimal point)_.

The cost price is exclusive of VAT. It can be entered at the custom level.

Verkoopprijs (verplicht)

Format: 00.00 (use a dot as a decimal point)

The sales price includes VAT. The sales price can be set at attribute level (for example, size).

Action Price

Format: 00.00 (use a dot as a decimal point)

When this value is entered it is placed in Afosto.

VAT (mandatory)

Format: 21 (without the percent sign)

Collections

Format: collection1;collection2

Menu items can be arranged (partially) using collections. A product can be assigned to multiple collections.

Weight (mandatory)

Format: round number between 0 and 12002.

Weight is used to calculate shipping costs. A number of dots can be specified here. The system uses this to calculate the shipping costs.

Description number

no weight 0

10 per envelope 9

5 per envelope 18

3 per envelope 30

2 per envelope 45

1 per envelope 90

100 per packet 120

50 per package 240

40 per package 300

25 per package 480

20 per package 600

10 per package 1200

5 per package 2400

4 per package 3000

2 per package 6000

1 per package 12000

otherwise 12001

Major Account

Format: text

The ledger account number can be specified here. This is used for reporting and links with accounting software.

Supplier

Format: text.

Here the supplier can be specified. This is used for extended reporting.

Images

Format: url, with separator: ;

Images can be imported from a URL. The entire URL should be placed in the file. It is also possible to import multiple images, this can be done by clicking on the link.

Parent

Format: 1 (otherwise leave empty)_.

The field parent is used to characterize a product with multiple options (variable product). For example shoes in different sizes. In the table below an example:

sku name parent size

shoe type xx 1

1001 shoe type xx 36

1002 shoe type xx 37

1003 shoe type xx 38 .

1004 shoe type xx 39

Products with 1 variant must be imported in the same way.

Attribute

Format: number or text

The field attribute is for example the size as given in the example under Parent. The column name is relevant, as it will be taken over during an import. It is important to have only 1 attribute per product.

Attributes can be used to filter on.

Specification

Format: number or text

It is possible to create up to 50 specifications. Specifications are used for various purposes. Of course to show with a product, but also for building breadcrumbs, filters, linked products or for automatically generating Titles, Seo titles, and so on.

Specifications can be used to filter on.

Example File

View and use this example file to get started with a product import